﻿--|--------------------------------------------------------------------------------
--| [DeleteAssignment] - Update Procedure Script for Entity
--|--------------------------------------------------------------------------------
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id (N'[dbo].[DeleteAssignment]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) 
	DROP PROCEDURE [dbo].[DeleteAssignment]
GO

CREATE PROCEDURE [dbo].[DeleteAssignment]
(
	@GameID int,
	@EntityID int
)
AS
	SET NOCOUNT ON
	DELETE FROM  GameEntity 
	WHERE 
	GameID = @GameID AND EntityID = @EntityID

	RETURN @@Error 
GO  